Re: function does not exist error...
От | Dan Jewett |
---|---|
Тема | Re: function does not exist error... |
Дата | |
Msg-id | p05200f06ba04218fd466@[162.84.132.56] обсуждение исходный текст |
Ответ на | Re: function does not exist error... (Josh Berkus <josh@agliodbs.com>) |
Список | pgsql-novice |
>Dan, > >> The big picture of what I'm trying to do is that I have large flat >> file of records created with info about individual recordings >> (songs). I want to split those out into appropriately referenced >> tables. >> >> I thought I could create a combination of rules and triggers to step >> through the table (or a text file exported from it) and send the data >> where it needs to go. Part of the process would be to check for >> existing entries to prevent redundency. I also want be able to add >> entries to join tables on the fly. > >Why do you want to use Triggers and Rules? Do you need to import this data >from source daily? Even so, batch processing will be faster than executing a >trigger for each row inserted. > >-- >-Josh Berkus You are right of course. Thanks for rearranging my thinking on this. So, on to figuring out the query for the batch. Dan
В списке pgsql-novice по дате отправления: